About

Amarjyoti Roy Chowdhury is a skilled Data Engineer with over 8 years of experience in the IT industry. He specializes in Data Engineering, Data Warehousing, ETL development, and SQL. Amarjyoti has extensive experience working with Informatica, SAP BO, SQL, and Unix, and has been involved in all phases of project implementation from requirement gathering to solution architecture, documentation, testing, and deployment support. Currently working as a Data Engineer at TCS, Amarjyoti has used AWS Glue for data transformation and validation, and data cleansing using PySpark and Python. He has identified data discrepancies using SQL to improve data cleansing methods, and has utilized AWS Lambda function for file validation on S3 bucket. Amarjyoti has also engaged extensively in coding using PySpark and Python to build end-to-end data pipelines using AWS, and has utilized Airflow for orchestrating workflows. Amarjyoti has previously worked as an Informatica Developer and DWH Developer at TCS. As an Informatica Developer, he was extensively engaged in data extraction, transformation, and loading data from various sources like Oracle, SQL Server, and Flat files. He developed end-to-end source systems with data integration workflows to connect and fetch data from multiple data sources and load into different targets. As a DWH Developer, Amarjyoti implemented effective date range mapping (SCD 2), designed complex mapping involving constraint-based loading, and target load order. He also developed BO reports, used advanced features like Derived tables, Index Awareness, Aggregate Awareness, custom LoVs, and created custom hierarchies and built cascading prompts. Amarjyoti holds a Bachelor of Technology degree in Electronics and Communications Engineering from Netaji Subhash Engineering College, where he graduated in 2014. Amarjyoti has a strong tech stack that includes Data Engineering, AWS, SQL, Python, AWS Glue, Snowflake, Databricks, ETL, Apache Airflow, Sagemaker, Integration, AI, Amazon Athena, MySQL, and Kafka. In addition to his technical skills, Amarjyoti is also a long-distance runner, table tennis player, and fitness freak.